Map Debug Tools
##
## === DIAGNOSTIC: Building Details All Students Data ===
## Number of rows: 105
## Column names: Building IRN, Building Name, District_IRN, District Name, County, Region, Student Group, Enrollment, Enrollment Percent, Attendance Rate, Mobility Rate, Chronic Absenteeism Rate
## Sample Building IRNs: 000224, 000489, 000575, 000729, 000736
## === After renaming columns ===
## # A tibble: 3 × 6
## SchoolIRN SchoolName Enrollment_Percent Attendance_Rate Mobility_Rate
## <chr> <chr> <chr> <chr> <chr>
## 1 000224 Adlai Stevenson Sc… 100.0 87.6 20.0
## 2 000489 Almira 100.0 86.1 8.5
## 3 000575 Northwest School o… 100.0 84.2 27.5
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <chr>
##
## === After numeric conversion ===
## # A tibble: 3 × 6
## SchoolIRN SchoolName Enrollment_Percent Attendance_Rate Mobility_Rate
## <chr> <chr> <dbl> <dbl> <dbl>
## 1 000224 Adlai Stevenson Sc… 1 0.876 0.2
## 2 000489 Almira 1 0.861 0.085
## 3 000575 Northwest School o… 1 0.842 0.275
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <dbl>
## Using geocoded school data
##
## === DIAGNOSTIC: Cleveland Schools Data (before merge) ===
## Number of rows: 105
## Column names: SchoolIRN ..., SchoolName ..., DistrictIRN ..., DistrictName ..., Latitude ..., Longitude ..., SyntheticCoords ..., geo_lat ..., geo_lng ..., geo_address ..., Address ...
## Sample SchoolIRNs: 000224, 000489, 000575, 000729, 000736
##
## === DIAGNOSTIC: SchoolIRN Comparison ===
## First 5 SchoolIRNs in Cleveland Schools Data: 000224, 000489, 000575, 000729, 000736
## First 5 SchoolIRNs in Building Details Data: 000224, 000489, 000575, 000729, 000736
## Number of matching SchoolIRNs: 105 out of 105 schools
##
## === DIAGNOSTIC: Cleveland Schools Data (after merge) ===
## Number of rows: 105
## Sample of joined data:
## # A tibble: 3 × 6
## SchoolName SchoolIRN Enrollment_Percent Attendance_Rate Mobility_Rate
## <chr> <chr> <dbl> <dbl> <dbl>
## 1 Adlai Stevenson Sc… 000224 1 0.876 0.2
## 2 Almira 000489 1 0.861 0.085
## 3 Northwest School o… 000575 1 0.842 0.275
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <dbl>
##
## Cleveland Buildings 22-23: 973 rows
## Cleveland Buildings 23-24: 936 rows
## Cleveland Buildings 23-24 (All Students): 105 rows
## Cleveland Student Opportunity 22-23: 1090 rows
## Cleveland Student Opportunity 23-24: 1050 rows
## Cleveland Schools Data: 105 rows
## Schools with values for Attendance Rate: 105
## Schools with values for Chronic Absenteeism Rate: 105
## Schools with values for Mobility Rate: 105
## Schools with values for Enrollment Percent: 105
## [1] "Schools data summary:"
## [1] "Number of schools: 105"
## [1] "School columns: SchoolIRN, SchoolName, DistrictIRN, DistrictName, Latitude, Longitude, SyntheticCoords, geo_lat, geo_lng, geo_address"
## [1] "Sample coordinates: -81.5509837, -81.7518031, -81.7671731 41.4548682, 41.4616156, 41.482455"
## Map dimensions: x
The map below allows you to select different performance indicators to visualize across schools in Cleveland. Each indicator is color-coded to show variation in performance, with HOLC redlining districts displayed as background polygons.
Select Performance Indicator:
## [1] "Available columns in cleveland_schools_data:"
## [1] "SchoolIRN" "SchoolName"
## [3] "DistrictIRN" "DistrictName"
## [5] "Latitude" "Longitude"
## [7] "SyntheticCoords" "geo_lat"
## [9] "geo_lng" "geo_address"
## [11] "Address" "Enrollment_Percent"
## [13] "Attendance_Rate" "Mobility_Rate"
## [15] "Chronic_Absenteeism_Rate"
Schools are displayed on top of the historical redlining districts from the 1930s HOLC. The system automatically handles “NC” (not counted) values by treating them as missing data. Use the dropdown above the map to switch between indicators - the school dots will change colors accordingly, and a dynamic legend shows the color scale for each indicator.
The maps below visualize data from the Building Student Opportunity Report for Cleveland schools. Each indicator shows opportunities and resources available to students, with HOLC redlining districts displayed as background polygons.
Select Student Opportunity Indicator:
## Loaded Student Opportunity data for 105 schools
## Available indicators:
## - All-Day Kindergarten Enrollment : 105 schools with data
## - Physical Education/Wellness Course Enrollment : 105 schools with data
## - World Language Course Enrollment : 105 schools with data
## - Career Technical Education Enrollment (Grades 7-12) : 105 schools with data
## - Cocurricular Activities Participation : 105 schools with data
## - Advanced Courses Participation (AP, IB, Honors, CCP) : 105 schools with data
## - Gifted Services : 105 schools with data
## - Enrichment/Support Programs Outside School Day : 105 schools with data
## - School Breakfast Program Participation : 105 schools with data
## - Students Transported by School Bus : 105 schools with data
## - Portable Technology Devices Ratio : 105 schools with data
Schools are displayed on top of the historical redlining districts from the 1930s HOLC grades. The system automatically handles “NC” (not counted) values by treating them as missing data. Use the dropdown above the map to switch between indicators.
This section visualizes data from the College, Career, Workforce, and Military Readiness (CCWMR) Overview report for Cleveland schools. Each indicator shows school performance on college and career readiness metrics, with HOLC redlining districts displayed as background polygons.
Select College and Career Readiness Indicator:
## [1] "Columns in Cleveland_CCWMR_23_24_Overview:"
## [1] "Building IRN"
## [2] "Building Name"
## [3] "District_IRN"
## [4] "District Name"
## [5] "County"
## [6] "Region"
## [7] "Number of Students in the 4-year Graduation Cohort who Completed a Pathway and are Prepared for College or Career Success"
## [8] "Graduation Cohort"
## [9] "Percent of Students in the 4-Year Graduation Cohort who Completed a Pathway and are Prepared for College or Career Success"
## [10] "Percent of Students Remediation Free on ACT or SAT"
## [11] "Honors Diploma Percent"
## [12] "Percent of Students who earned 3 or more 3+ AP or 4+ IB Tests"
## [13] "Percent of Students who Earned at Least 12 Credential Points in a Single Career Field or a State Recognized License"
## [14] "Percent of Students who Earned 12 or more Dual Enrollment Credits"
## [15] "Percent of Students Enlisted in Military"
## [16] "Percent of Students Accepted into an Apprenticeship Program Post High School"
## [17] "Percent of Students Completing a Pre-Apprenticeship"
## [18] "Percent of Students Completing an Apprenticeship"
## [19] "Percent of Students Achieving Proficiency on 3 or More Technical Assessments"
## [20] "Percent of Students Earning the Ohio Means Jobs Readiness Seal and 250+ Hours of Work-Based Learning"
## [21] "Watermark"
##
## Summary of data for each indicator (before modifications):
## pathway_success: 31 schools with data, 74 schools with NC values (70%)
## remediation_free: 31 schools with data, 74 schools with NC values (70%)
## honors_diploma: 31 schools with data, 74 schools with NC values (70%)
## ap_ib_success: 31 schools with data, 74 schools with NC values (70%)
## credential_points: 31 schools with data, 74 schools with NC values (70%)
## dual_enrollment: 31 schools with data, 74 schools with NC values (70%)
## military: 31 schools with data, 74 schools with NC values (70%)
## apprenticeship_accepted: 31 schools with data, 74 schools with NC values (70%)
## pre_apprenticeship: 31 schools with data, 74 schools with NC values (70%)
## apprenticeship_complete: 31 schools with data, 74 schools with NC values (70%)
## technical_assessments: 31 schools with data, 74 schools with NC values (70%)
## omj_readiness: 31 schools with data, 74 schools with NC values (70%)
## Prepared CCWMR Overview data for 105 schools
## Indicator: pathway_success - Found 74 schools with NC/NA values
## Indicator: pathway_success - Using range: 0 % to 100 %
## Indicator: remediation_free - Found 74 schools with NC/NA values
## Indicator: remediation_free - Using range: 0 % to 40 %
## Indicator: honors_diploma - Found 74 schools with NC/NA values
## Indicator: honors_diploma - Using range: 0 % to 30 %
## Indicator: ap_ib_success - Found 74 schools with NC/NA values
## Indicator: ap_ib_success - Using range: 0 % to 30 %
## Indicator: credential_points - Found 74 schools with NC/NA values
## Indicator: credential_points - Using range: 0 % to 70 %
## Indicator: dual_enrollment - Found 74 schools with NC/NA values
## Indicator: dual_enrollment - Using range: 0 % to 100 %
## Indicator: military - Found 74 schools with NC/NA values
## Indicator: military - Using range: 0 % to 20 %
## Indicator: apprenticeship_accepted - Found 74 schools with NC/NA values
## Indicator: apprenticeship_accepted - Using range: 0 % to 20 %
## Indicator: pre_apprenticeship - Found 74 schools with NC/NA values
## Indicator: pre_apprenticeship - Using range: 0 % to 30 %
## Indicator: apprenticeship_complete - Found 74 schools with NC/NA values
## Indicator: apprenticeship_complete - Using range: 0 % to 20 %
## Indicator: technical_assessments - Found 74 schools with NC/NA values
## Indicator: technical_assessments - Using range: 0 % to 30 %
## Indicator: omj_readiness - Found 74 schools with NC/NA values
## Indicator: omj_readiness - Using range: 0 % to 20 %
Schools are displayed on top of the historical redlining districts from the 1930s HOLC grades. Schools with white circles indicate “Not Counted (NC)” values in the dataset.
This section visualizes data from the College, Career, Workforce, and Military Readiness (CCWMR) report for Cleveland schools. Each indicator shows student participation and achievement in college readiness metrics, with HOLC redlining districts displayed as background polygons.
Select College and Career Readiness Indicator:
## [1] "Columns in Cleveland_CCWMR_23_24_Additional_Details:"
## [1] "Building IRN"
## [2] "Building Name"
## [3] "District_IRN"
## [4] "District Name"
## [5] "County"
## [6] "Region"
## [7] "ACT Participation Percent"
## [8] "Percent of Students Remediation Free on ACT"
## [9] "SAT Participation Percent"
## [10] "Percent of Students Remediation Free on SAT"
## [11] "AP Participation Percent"
## [12] "IB Participation Percent"
## [13] "Percent of Students Earning 3+ on AP Test"
## [14] "Percent of Students Earning 4+ on IB Test"
## [15] "Watermark"
## No 'Student Group' column found, using all 105 rows
##
## Summary of ACT Participation data before modifications:
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 0.00000 0.00000 0.01400 0.04513 0.02700 0.72700 74
## Number of schools with NA (NC) values: 74
## Column act_participation has 74 missing values
## Preserving 74 NC values for act_participation
## Column act_remediation has 74 missing values
## Preserving 74 NC values for act_remediation
## Column sat_participation has 74 missing values
## Preserving 74 NC values for sat_participation
## Column sat_remediation has 74 missing values
## Preserving 74 NC values for sat_remediation
## Column ap_participation has 74 missing values
## Preserving 74 NC values for ap_participation
## Column ib_participation has 74 missing values
## Preserving 74 NC values for ib_participation
## Column ap_success has 74 missing values
## Preserving 74 NC values for ap_success
## Column ib_success has 74 missing values
## Preserving 74 NC values for ib_success
##
## Summary of ACT Participation data after modifications:
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 0.00000 0.00000 0.01400 0.04513 0.02700 0.72700 74
## Number of schools with NA (NC) values: 74
## Prepared CCWMR data for 105 schools
## Indicator: act_participation - Found 74 schools with NC/NA values
## Excluded 1 specific schools from act_participation map
## Value distribution for act_participation :
##
## 0 0.9 1 1.1 1.3 1.4 1.5 1.6 2 2.1 2.6 2.8 3.1 4.4 5.4 13.2
## 9 1 1 1 2 2 1 2 2 1 1 2 1 1 1 1
## 13.7
## 1
## Schools with ~1.4% ACT Participation:
## name
## 1 Glenville High School
## 2 Lincoln West School Of Global Studies
## 3 Rhodes School of Environmental Studies
## 4 Garrett Morgan School of Engineering & Innovation
## 5 Cleveland School Of The Arts High School
## Indicator: act_participation - Using range: 0 % to 30 %
## Indicator: act_remediation - Found 74 schools with NC/NA values
## Value distribution for act_remediation :
##
## 0 1.1 2.9
## 29 1 1
## Indicator: act_remediation - Using range: 0 % to 20 %
## Indicator: sat_participation - Found 74 schools with NC/NA values
## Value distribution for sat_participation :
##
## 0 20 33.3 41.3 46.2 52 53.8 55.1 55.5 56 60.4 60.9 61.5 62.5 65.3 66.7
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 67.1 69.5 69.7 70.8 72.1 74.8 80.4 81.5 87.7 89.1 90.1 91.8 92.4 93.7 97.1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## Indicator: sat_participation - Using range: 0 % to 100 %
## Indicator: sat_remediation - Found 74 schools with NC/NA values
## Value distribution for sat_remediation :
##
## 0 1.3 1.4 1.5 1.8 2.1 2.3 2.6 2.8 3.1 4.1 4.9 5.3 5.8 7 7.4
## 10 1 1 2 1 1 1 1 1 1 1 1 2 1 1 1
## 9.4 16.5 24.2 26.5
## 1 1 1 1
## Indicator: sat_remediation - Using range: 0 % to 40 %
## Indicator: ap_participation - Found 74 schools with NC/NA values
## Value distribution for ap_participation :
##
## 0 1.3 1.5 1.8 2 4.5 4.6 5.6 6.4 16.7 17.4 20 20.2 20.4 20.8 21.4
## 7 1 1 2 1 1 1 2 1 1 1 1 1 1 1 2
## 27.4 28 30.8 84.4 96.8 97.1
## 1 1 1 1 1 1
## Indicator: ap_participation - Using range: 0 % to 100 %
## Indicator: ib_participation - Found 74 schools with NC/NA values
## Value distribution for ib_participation :
##
## 0
## 31
## Indicator: ib_participation - Using range: 0 % to 20 %
## Indicator: ap_success - Found 74 schools with NC/NA values
## Value distribution for ap_success :
##
## 0 1.3 1.4 1.6 2.9 4.3 6.2 6.3 7.1 7.5 10.9 21.1 22.1
## 18 1 1 1 1 1 1 2 1 1 1 1 1
## Indicator: ap_success - Using range: 0 % to 30 %
## Indicator: ib_success - Found 74 schools with NC/NA values
## Value distribution for ib_success :
##
## 0
## 31
## Indicator: ib_success - Using range: 0 % to 20 %
Schools are displayed on top of the historical redlining districts from the 1930s HOLC grades. Schools with white circles indicate “Not Counted (NC)” values in the dataset. For the ACT Participation map, Northeast Ohio College Preparatory School (72.7% participation) is excluded as it is a College Prep oriented school with disproportionately higher participation than other schools.
This section visualizes data from the College, Career, Workforce, and Military Readiness (CCWMR) Follow-Up Collection report for Cleveland schools. Each indicator shows post-graduation outcomes for students, with HOLC redlining districts displayed as background polygons.
Select Post-Graduation Outcome Indicator:
## [1] "Columns in Cleveland_CCWMR_23_24_Follow_Up_Collection:"
## [1] "Building IRN"
## [2] "Building Name"
## [3] "District_IRN"
## [4] "District Name"
## [5] "County"
## [6] "Region"
## [7] "Denominator (2023 Graduates)"
## [8] "Number of Students Enrolled in Post-Secondary Education"
## [9] "Percent of Students Enrolled in Post-Secondary Education"
## [10] "Number of Students Enrolled in 2-Year Post-Secondary Institution"
## [11] "Percent of Students Enrolled in 2-Year Post-Secondary Institution"
## [12] "Number of Students Enrolled in 4-Year Post-Secondary Institution"
## [13] "Percent of Students Enrolled in 4-Year Post-Secondary Institution"
## [14] "Number of Students Enrolled in Ohio Technical School"
## [15] "Percent of Students Enrolled in Ohio Technical School"
## [16] "Number of Students Enrolled in Other Post-Secondary Institution"
## [17] "Percent of Students Enrolled in Other Post-Secondary Institution"
## [18] "Number of Students Entered into Apprenticeship or Other Job Training"
## [19] "Percent of Students Entered into Apprenticeship or Other Job Training"
## [20] "Number of Students Gainfully Employed"
## [21] "Percent of Students Gainfully Employed"
## [22] "Number of Students Enlisted in Military"
## [23] "Percent of Students Enlisted in Military"
## [24] "Watermark"
##
## Summary of data for each indicator (before modifications):
## postsecondary: 31 schools with data, 74 schools with NC values (70%)
## twoyear: 31 schools with data, 74 schools with NC values (70%)
## fouryear: 31 schools with data, 74 schools with NC values (70%)
## technical: 31 schools with data, 74 schools with NC values (70%)
## other: 31 schools with data, 74 schools with NC values (70%)
## apprenticeship: 31 schools with data, 74 schools with NC values (70%)
## employed: 31 schools with data, 74 schools with NC values (70%)
## military: 31 schools with data, 74 schools with NC values (70%)
## Prepared CCWMR Follow-Up data for 105 schools
## Indicator: postsecondary - Found 74 schools with NC/NA values
## Indicator: postsecondary - Using range: 0 % to 80 %
## Indicator: twoyear - Found 74 schools with NC/NA values
## Indicator: twoyear - Using range: 0 % to 40 %
## Indicator: fouryear - Found 74 schools with NC/NA values
## Indicator: fouryear - Using range: 0 % to 70 %
## Indicator: technical - Found 74 schools with NC/NA values
## Indicator: technical - Using range: 0 % to 20 %
## Indicator: other - Found 74 schools with NC/NA values
## Indicator: other - Using range: 0 % to 20 %
## Indicator: apprenticeship - Found 74 schools with NC/NA values
## Indicator: apprenticeship - Using range: 0 % to 20 %
## Indicator: employed - Found 74 schools with NC/NA values
## Indicator: employed - Using range: 0 % to 60 %
## Indicator: military - Found 74 schools with NC/NA values
## Indicator: military - Using range: 0 % to 20 %
Schools are displayed on top of the historical redlining districts from the 1930s HOLC grades. Schools with white circles indicate “Not Counted (NC)” values in the dataset. The data represents outcomes for 2023 graduates as reported in the 2023-24 school year collection.